package com.hanthink.system.mapper.repair;

import java.util.List;
import java.util.Map;

import com.hanthink.system.domain.repair.RequestInfo;
import io.lettuce.core.dynamic.annotation.Param;

/**
 * @author Administrator 报修单
 */
public interface RequestMapper {
	/**
	 * 通过工厂KEY查询待指派的报修单
	 * 
	 * @param siteKey 工厂Key
	 * @return 结果
	 */
    List<RequestInfo> selectRequestVo(Long siteKey);

	List<RequestInfo> selectRequestVoPlus(Map<String, Object> params);

	List<RequestInfo> selectRequestinforListnotget(Map<String, Object> params);

	List<RequestInfo> selectRequestinforListget(Map<String, Object> params);


	List<RequestInfo> selectRequestinforListallocation(Map<String, Object> params);


	int updateassign(Map<String, Object> params);

	List<RequestInfo> selectRequestVobx(Long siteKey);

	List<RequestInfo> selectRequestVobxbyCode(Map<String, Object> params);

    List<RequestInfo> selectNoFinishedRequestVo(RequestInfo requestInfo);

	int updateRequest(Map<String, Object> params);

	int updateRequestByID(Map<String, Object> params);

	int updateRequestByIDdeletedept(Map<String, Object> params);



    int updateRequestPrompt(RequestInfo requestInfo);

	/**
	 * 通过工厂KEY查询已指派的报修单
	 * 
	 * @param siteKey 工厂Key
	 * @return 结果
	 */
    List<RequestInfo> selectCheckedList(Long siteKey);


	List<RequestInfo> checkedListzhengyi1(String siteKey);

	List<RequestInfo> checkedListzhengyi2(String siteKey);

	List<RequestInfo> checkedListzhengyi99(Map<String, Object> map);

	List<RequestInfo> checkedListzhengyi4(Long siteKey);

	List<RequestInfo> checkedListzhengyi5(Long siteKey);

	List<RequestInfo> checkedListzhengyi50(Long siteKey);
	List<RequestInfo> checkedListzhengyi51(Long siteKey);
	int checkedListzhengyi3(Long siteKey);

	int checkedListzhengyi31(Long siteKey);

	int checkedListzhengyi32(Long siteKey);

	int checkedListzhengyi6(Map<String, Object> map);

	int checkedListzhengyi88(Map<String, Object> map);

	int checkedListzhengyi61(Map<String, Object> map);

	int checkedListzhengyi62(Map<String, Object> map);

	int checkedListzhengyi7(Map<String, Object> map);

	List<RequestInfo>  checkedListzhengyi10(Map<String, Object> map);

	List<RequestInfo>  checkedListzhengyi15(Map<String, Object> map);

	List<RequestInfo> selectCheckedListOverTime();

	void updateCheckedListOverTime(@Param("id") Long id);

    int insertRequest(RequestInfo requestInfo);


	RequestInfo selectRequestVoById(Long id);


	String selectRequestVoByName(String equipName);
}
